--exec dbo.get_class_childs  0
use anton
go
create procedure    get_class_childs   @parent int  
as
 
SELECT [node_id]
      ,[class_name]
      ,[is_item]
      ,[max_value]
      ,[desc]
  FROM [anton].[dbo].[class]
where [parent_node_id] = @parent


go